/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : localhost:3306
 Source Schema         : tp-vue

 Target Server Type    : MySQL
 Target Server Version : 80017
 File Encoding         : 65001

 Date: 07/08/2019 17:09:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `user_id` int(11) NOT NULL,
  `create_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `publish_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `group_id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '组名',
  `enabled` tinyint(1) DEFAULT '0' COMMENT '是否启用',
  `description` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '描述',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
INSERT INTO `auth_group` VALUES (1, '超级管理员', 1, '拥有最高权限', '2019-07-31 10:55:50', '2019-07-31 10:55:53', NULL);
INSERT INTO `auth_group` VALUES (2, '普通管理员', 1, NULL, '2019-07-31 10:55:56', '2019-07-31 10:55:59', NULL);
INSERT INTO `auth_group` VALUES (3, '编辑', 1, NULL, '2019-07-31 11:15:00', '2019-07-31 11:15:00', NULL);
INSERT INTO `auth_group` VALUES (4, '游戏', 1, NULL, '2019-07-31 11:16:00', '2019-08-01 10:44:53', NULL);
INSERT INTO `auth_group` VALUES (5, '其它', 1, '测试其它', '2019-07-31 11:16:08', '2019-08-01 10:42:15', NULL);
INSERT INTO `auth_group` VALUES (6, '老克勒左', 1, '老克勒左穿校服大风大', '2019-07-31 11:24:16', '2019-08-01 11:41:38', '2019-08-01 11:41:38');
COMMIT;

-- ----------------------------
-- Table structure for auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `auth_rule`;
CREATE TABLE `auth_rule` (
  `rule_id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) DEFAULT NULL COMMENT '上级ID',
  `route_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '菜单路径',
  `route_name` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '名称',
  `route_redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '跳转路径',
  `title` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '权限名称',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'ICON',
  `enabled` tinyint(1) DEFAULT NULL COMMENT '是否启用',
  `post_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '请求路径',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  `is_menu` tinyint(1) DEFAULT '1' COMMENT '类型 1菜单 0 操作',
  PRIMARY KEY (`rule_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of auth_rule
-- ----------------------------
BEGIN;
INSERT INTO `auth_rule` VALUES (1, 0, '/', 'Dashboard', '/dashboard', 'Dashboard', 'dashboard', 1, '/', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (2, 0, '/user', 'User', '/example/table', 'Example', 'example', 1, '/user', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (3, 2, '/user/list', 'User List', '', 'User List', 'table', 1, '/user/list', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (4, 2, '/user/groups', 'User Groups', ' ', 'User Group', 'tree', 1, '/group/list', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (5, 0, '/menu', 'Menu', '', 'Menu', 'tree', 1, '/menu', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (6, 5, '/menu/list', 'Menu List', ' ', 'Menu List', 'form', 1, '/menu/list', NULL, NULL, NULL, 1);
INSERT INTO `auth_rule` VALUES (7, 3, '12321', 'RouteName', '321', '321', '32', 1, '', '2019-08-02 11:09:47', '2019-08-02 11:09:47', NULL, 0);
INSERT INTO `auth_rule` VALUES (8, 4, 'fdafdaf', 'fdafda', 'daf', 'daf', 'a', 1, '', '2019-08-02 11:10:39', '2019-08-02 11:10:39', NULL, 0);
INSERT INTO `auth_rule` VALUES (9, 3, '#', 'Edit', '#', 'Edit', 'form', 1, '', '2019-08-02 13:46:43', '2019-08-02 13:46:43', NULL, 0);
INSERT INTO `auth_rule` VALUES (10, 4, '#', 'Edit', '#', 'Edit', 'form', 1, '', '2019-08-02 13:47:30', '2019-08-02 13:47:30', NULL, 0);
INSERT INTO `auth_rule` VALUES (11, 0, 'Other', 'AAAA', 'AAA', 'AAA', 'form', 1, '', '2019-08-02 13:50:20', '2019-08-02 15:08:38', '2019-08-02 15:08:38', 1);
INSERT INTO `auth_rule` VALUES (12, 11, 'Test', 'Test', 'Test', 'Test', 'form', 0, '', '2019-08-02 14:15:02', '2019-08-02 15:08:32', '2019-08-02 15:08:32', 1);
INSERT INTO `auth_rule` VALUES (14, 1, '3213', '321', '213', '21', '3213', 1, '', '2019-08-02 14:18:12', '2019-08-02 15:08:46', '2019-08-02 15:08:46', 1);
INSERT INTO `auth_rule` VALUES (15, 11, 'dafda', 'fdafdaf', 'fdafda', 'fdafdsaf', 'dafdsa', 1, '', '2019-08-02 14:18:33', '2019-08-02 15:08:29', '2019-08-02 15:08:29', 1);
INSERT INTO `auth_rule` VALUES (16, 2, 'EEEEE', 'EEEEE', 'EEEEE', 'EEEEE', 'EEEEE', 1, '', '2019-08-02 14:32:51', '2019-08-02 15:01:44', '2019-08-02 15:01:44', 1);
INSERT INTO `auth_rule` VALUES (17, 16, 'fdafdas', 'fdafdafda', 'fdafdsaf', 'dafdsa', 'fdafda', 1, '', '2019-08-02 14:33:07', '2019-08-02 15:01:36', '2019-08-02 15:01:36', 1);
INSERT INTO `auth_rule` VALUES (18, 2, '/user/info', 'User Info', '', 'User Info', 'table', 1, '/user/info', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (19, 2, '/auth/rights', 'User Rights', '', 'User Rights', 'table', 1, '/auth/rights', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (20, 2, '/user/logout', 'User Logout', NULL, 'User Logout', 'table', 1, '/user/logout', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (21, 4, '/user/groups/update', 'Group Update', NULL, 'Group Update', 'table', 1, '/group/update', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (22, 4, '/user/groups/delete', 'Group Delete', NULL, 'Group Delete', 'table ', 1, '/group/del', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (23, 4, '/user/groups/haveAuth', 'Group Has Access', NULL, 'Group Access', 'table', 1, '/group/haveAuth', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (24, 2, '/user/update', 'User Update', NULL, 'User Update', 'table', 1, '/user/update', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (25, 2, '/user/del', 'User Del', NULL, 'User Del', 'table', 1, '/user/del', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (26, 2, '/user/create', 'User Create', NULL, 'User Create', 'table', 1, '/user/create', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (27, 4, '/user/groups/create', 'Group Create', NULL, 'Gruop Create', 'table', 1, '/group/create', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (28, 6, '/menu/update', 'Menu Update', NULL, 'Menu Update', 'table', 1, '/menu/update', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (29, 6, '/menu/del', 'Menu Del', NULL, 'Menu Del', 'table', 1, '/menu/del', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (30, 6, '/menu/create', 'Menu Create', NULL, 'Menu Create', 'table', 1, '/menu/create', NULL, NULL, NULL, 0);
INSERT INTO `auth_rule` VALUES (32, 4, '/user/group/saveAuth', 'SaveAuth', NULL, 'SaveAuth', 'table', 1, '/auth/saveAuth', NULL, NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for group_rule_access
-- ----------------------------
DROP TABLE IF EXISTS `group_rule_access`;
CREATE TABLE `group_rule_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `rule_id` int(11) NOT NULL,
  `create_at` datetime DEFAULT NULL,
  `update_at` datetime DEFAULT NULL,
  `delete_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=207 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of group_rule_access
-- ----------------------------
BEGIN;
INSERT INTO `group_rule_access` VALUES (1, 1, 1, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (2, 1, 2, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (3, 1, 3, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (4, 1, 4, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (5, 1, 5, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (6, 1, 6, NULL, '2019-08-01 11:42:18', '2019-08-01 11:42:18');
INSERT INTO `group_rule_access` VALUES (7, 2, 1, NULL, '2019-08-07 16:07:51', '2019-08-07 16:07:51');
INSERT INTO `group_rule_access` VALUES (8, 2, 2, NULL, '2019-08-07 16:07:51', '2019-08-07 16:07:51');
INSERT INTO `group_rule_access` VALUES (9, 6, 5, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (10, 6, 6, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (11, 6, 3, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (12, 6, 5, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (13, 6, 6, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (14, 6, 3, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (15, 6, 5, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (16, 6, 6, NULL, '2019-08-01 11:29:16', '2019-08-01 11:29:16');
INSERT INTO `group_rule_access` VALUES (17, 6, 3, NULL, '2019-08-01 11:30:03', '2019-08-01 11:30:03');
INSERT INTO `group_rule_access` VALUES (18, 6, 5, NULL, '2019-08-01 11:30:03', '2019-08-01 11:30:03');
INSERT INTO `group_rule_access` VALUES (19, 6, 6, NULL, '2019-08-01 11:30:03', '2019-08-01 11:30:03');
INSERT INTO `group_rule_access` VALUES (20, 6, 3, NULL, '2019-08-01 11:30:20', '2019-08-01 11:30:20');
INSERT INTO `group_rule_access` VALUES (21, 6, 5, NULL, '2019-08-01 11:30:20', '2019-08-01 11:30:20');
INSERT INTO `group_rule_access` VALUES (22, 6, 6, NULL, '2019-08-01 11:30:20', '2019-08-01 11:30:20');
INSERT INTO `group_rule_access` VALUES (23, 6, 2, NULL, '2019-08-01 11:31:45', '2019-08-01 11:31:45');
INSERT INTO `group_rule_access` VALUES (24, 6, 3, NULL, '2019-08-01 11:31:45', '2019-08-01 11:31:45');
INSERT INTO `group_rule_access` VALUES (25, 6, 4, NULL, '2019-08-01 11:31:45', '2019-08-01 11:31:45');
INSERT INTO `group_rule_access` VALUES (26, 6, 5, NULL, '2019-08-01 11:31:45', '2019-08-01 11:31:45');
INSERT INTO `group_rule_access` VALUES (27, 6, 6, NULL, '2019-08-01 11:31:45', '2019-08-01 11:31:45');
INSERT INTO `group_rule_access` VALUES (28, 5, 2, NULL, '2019-08-01 11:31:23', '2019-08-01 11:31:23');
INSERT INTO `group_rule_access` VALUES (29, 5, 3, NULL, '2019-08-01 11:31:23', '2019-08-01 11:31:23');
INSERT INTO `group_rule_access` VALUES (30, 5, 4, NULL, '2019-08-01 11:31:23', '2019-08-01 11:31:23');
INSERT INTO `group_rule_access` VALUES (31, 5, 1, NULL, '2019-08-01 11:31:59', '2019-08-01 11:31:59');
INSERT INTO `group_rule_access` VALUES (32, 5, 2, NULL, '2019-08-01 11:31:59', '2019-08-01 11:31:59');
INSERT INTO `group_rule_access` VALUES (33, 5, 3, NULL, '2019-08-01 11:31:59', '2019-08-01 11:31:59');
INSERT INTO `group_rule_access` VALUES (34, 5, 4, NULL, '2019-08-01 11:31:59', '2019-08-01 11:31:59');
INSERT INTO `group_rule_access` VALUES (35, 6, 1, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (36, 6, 2, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (37, 6, 3, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (38, 6, 4, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (39, 6, 5, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (40, 6, 6, NULL, '2019-08-01 11:32:02', '2019-08-01 11:32:02');
INSERT INTO `group_rule_access` VALUES (41, 4, 1, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (42, 4, 2, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (43, 4, 3, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (44, 4, 4, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (45, 4, 5, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (46, 4, 6, NULL, '2019-08-01 11:42:12', '2019-08-01 11:42:12');
INSERT INTO `group_rule_access` VALUES (47, 3, 4, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (48, 5, 2, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (49, 5, 3, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (50, 5, 4, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (51, 6, 1, NULL, '2019-08-01 11:41:38', '2019-08-01 11:41:38');
INSERT INTO `group_rule_access` VALUES (52, 6, 5, NULL, '2019-08-01 11:41:38', '2019-08-01 11:41:38');
INSERT INTO `group_rule_access` VALUES (53, 6, 6, NULL, '2019-08-01 11:41:38', '2019-08-01 11:41:38');
INSERT INTO `group_rule_access` VALUES (54, 4, 3, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (55, 4, 5, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (56, 4, 6, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (57, 1, 1, NULL, '2019-08-01 11:42:23', '2019-08-01 11:42:23');
INSERT INTO `group_rule_access` VALUES (58, 1, 5, NULL, '2019-08-01 11:42:23', '2019-08-01 11:42:23');
INSERT INTO `group_rule_access` VALUES (59, 1, 6, NULL, '2019-08-01 11:42:23', '2019-08-01 11:42:23');
INSERT INTO `group_rule_access` VALUES (60, 1, 1, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (61, 1, 2, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (62, 1, 3, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (63, 1, 4, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (64, 1, 5, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (65, 1, 6, NULL, '2019-08-02 14:14:02', '2019-08-02 14:14:02');
INSERT INTO `group_rule_access` VALUES (66, 1, 1, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (67, 1, 2, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (68, 1, 3, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (69, 1, 4, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (70, 1, 5, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (71, 1, 6, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (72, 1, 11, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (73, 2, 1, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (74, 2, 3, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (75, 2, 7, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (76, 2, 9, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (77, 2, 8, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (78, 2, 10, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (79, 2, 18, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (80, 2, 19, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (81, 2, 20, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (82, 2, 24, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (83, 2, 25, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (84, 2, 26, NULL, '2019-08-07 16:10:56', '2019-08-07 16:10:56');
INSERT INTO `group_rule_access` VALUES (85, 2, 1, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (86, 2, 3, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (87, 2, 7, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (88, 2, 9, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (89, 2, 8, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (90, 2, 10, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (91, 2, 18, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (92, 2, 19, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (93, 2, 20, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (94, 2, 24, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (95, 2, 25, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (96, 2, 26, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (97, 2, 5, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (98, 2, 6, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (99, 2, 28, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (100, 2, 29, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (101, 2, 30, NULL, '2019-08-07 16:11:26', '2019-08-07 16:11:26');
INSERT INTO `group_rule_access` VALUES (102, 2, 1, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (103, 2, 3, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (104, 2, 7, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (105, 2, 9, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (106, 2, 8, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (107, 2, 10, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (108, 2, 21, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (109, 2, 22, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (110, 2, 18, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (111, 2, 19, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (112, 2, 20, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (113, 2, 24, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (114, 2, 25, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (115, 2, 26, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (116, 2, 28, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (117, 2, 30, NULL, '2019-08-07 16:33:24', '2019-08-07 16:33:24');
INSERT INTO `group_rule_access` VALUES (118, 2, 1, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (119, 2, 3, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (120, 2, 7, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (121, 2, 9, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (122, 2, 8, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (123, 2, 10, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (124, 2, 18, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (125, 2, 19, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (126, 2, 20, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (127, 2, 24, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (128, 2, 25, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (129, 2, 26, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (130, 2, 28, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (131, 2, 30, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (132, 2, 2, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (133, 2, 4, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (134, 2, 5, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (135, 2, 6, NULL, '2019-08-07 16:58:29', '2019-08-07 16:58:29');
INSERT INTO `group_rule_access` VALUES (136, 2, 1, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (137, 2, 2, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (138, 2, 3, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (139, 2, 7, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (140, 2, 9, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (141, 2, 4, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (142, 2, 8, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (143, 2, 10, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (144, 2, 21, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (145, 2, 18, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (146, 2, 19, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (147, 2, 20, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (148, 2, 24, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (149, 2, 25, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (150, 2, 26, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (151, 2, 5, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (152, 2, 6, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (153, 2, 28, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (154, 2, 30, NULL, '2019-08-07 16:58:59', '2019-08-07 16:58:59');
INSERT INTO `group_rule_access` VALUES (155, 2, 1, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (156, 2, 2, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (157, 2, 3, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (158, 2, 7, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (159, 2, 9, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (160, 2, 4, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (161, 2, 8, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (162, 2, 10, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (163, 2, 21, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (164, 2, 22, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (165, 2, 18, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (166, 2, 19, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (167, 2, 20, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (168, 2, 24, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (169, 2, 25, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (170, 2, 26, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (171, 2, 5, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (172, 2, 6, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (173, 2, 28, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (174, 2, 30, NULL, '2019-08-07 16:59:11', '2019-08-07 16:59:11');
INSERT INTO `group_rule_access` VALUES (175, 2, 1, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (176, 2, 2, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (177, 2, 3, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (178, 2, 7, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (179, 2, 9, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (180, 2, 4, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (181, 2, 8, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (182, 2, 10, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (183, 2, 21, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (184, 2, 22, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (185, 2, 5, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (186, 2, 6, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (187, 2, 28, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (188, 2, 30, NULL, '2019-08-07 17:02:02', '2019-08-07 17:02:02');
INSERT INTO `group_rule_access` VALUES (189, 2, 1, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (190, 2, 2, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (191, 2, 3, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (192, 2, 7, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (193, 2, 9, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (194, 2, 4, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (195, 2, 8, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (196, 2, 10, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (197, 2, 18, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (198, 2, 19, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (199, 2, 20, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (200, 2, 24, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (201, 2, 25, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (202, 2, 26, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (203, 2, 5, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (204, 2, 6, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (205, 2, 28, NULL, NULL, NULL);
INSERT INTO `group_rule_access` VALUES (206, 2, 30, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for system_log
-- ----------------------------
DROP TABLE IF EXISTS `system_log`;
CREATE TABLE `system_log` (
  `log_id` int(9) NOT NULL AUTO_INCREMENT COMMENT '日志ID',
  `level` enum('debug','info','waring','') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '日志错误级别',
  `code` varchar(8) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '错误编码',
  `msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '错误信息',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of system_log
-- ----------------------------
BEGIN;
INSERT INTO `system_log` VALUES (1, 'info', '999999', 'Undefined index: rule_id', '2019-08-02 14:45:26', '2019-08-02 14:45:26', NULL);
INSERT INTO `system_log` VALUES (2, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-02 15:43:26', '2019-08-02 15:43:26', NULL);
INSERT INTO `system_log` VALUES (3, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-02 15:43:26', '2019-08-02 15:43:26', NULL);
INSERT INTO `system_log` VALUES (4, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:51:07', '2019-08-05 08:51:07', NULL);
INSERT INTO `system_log` VALUES (5, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:51:07', '2019-08-05 08:51:07', NULL);
INSERT INTO `system_log` VALUES (6, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:51:26', '2019-08-05 08:51:26', NULL);
INSERT INTO `system_log` VALUES (7, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:51:26', '2019-08-05 08:51:26', NULL);
INSERT INTO `system_log` VALUES (8, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:53:46', '2019-08-05 08:53:46', NULL);
INSERT INTO `system_log` VALUES (9, 'info', '999999', 'Call to undefined function app\\middleware\\hasAuth()', '2019-08-05 08:53:46', '2019-08-05 08:53:46', NULL);
INSERT INTO `system_log` VALUES (10, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:16', '2019-08-05 09:18:16', NULL);
INSERT INTO `system_log` VALUES (11, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:16', '2019-08-05 09:18:16', NULL);
INSERT INTO `system_log` VALUES (12, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:22', '2019-08-05 09:18:22', NULL);
INSERT INTO `system_log` VALUES (13, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:22', '2019-08-05 09:18:22', NULL);
INSERT INTO `system_log` VALUES (14, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:29', '2019-08-05 09:18:29', NULL);
INSERT INTO `system_log` VALUES (15, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:18:29', '2019-08-05 09:18:29', NULL);
INSERT INTO `system_log` VALUES (16, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:20:57', '2019-08-05 09:20:57', NULL);
INSERT INTO `system_log` VALUES (17, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:20:57', '2019-08-05 09:20:57', NULL);
INSERT INTO `system_log` VALUES (18, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:22:04', '2019-08-05 09:22:04', NULL);
INSERT INTO `system_log` VALUES (19, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:22:04', '2019-08-05 09:22:04', NULL);
INSERT INTO `system_log` VALUES (20, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:23:02', '2019-08-05 09:23:02', NULL);
INSERT INTO `system_log` VALUES (21, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:23:02', '2019-08-05 09:23:02', NULL);
INSERT INTO `system_log` VALUES (22, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:26:33', '2019-08-05 09:26:33', NULL);
INSERT INTO `system_log` VALUES (23, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:26:33', '2019-08-05 09:26:33', NULL);
INSERT INTO `system_log` VALUES (24, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:27:36', '2019-08-05 09:27:36', NULL);
INSERT INTO `system_log` VALUES (25, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:27:36', '2019-08-05 09:27:36', NULL);
INSERT INTO `system_log` VALUES (26, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:29:55', '2019-08-05 09:29:55', NULL);
INSERT INTO `system_log` VALUES (27, 'info', '999999', 'Class \'app\\exception\\UnassignedRoles\' not found', '2019-08-05 09:29:55', '2019-08-05 09:29:55', NULL);
INSERT INTO `system_log` VALUES (28, 'info', '999999', 'Class \'app\\exception\\auth\\AuthFailure\' not found', '2019-08-05 09:31:22', '2019-08-05 09:31:22', NULL);
INSERT INTO `system_log` VALUES (29, 'info', '999999', 'Class \'app\\exception\\auth\\AuthFailure\' not found', '2019-08-05 09:31:22', '2019-08-05 09:31:22', NULL);
INSERT INTO `system_log` VALUES (30, 'info', '999999', 'controller not exists:d8d164584a9c417b2b8d.hot-update.json', '2019-08-05 10:47:41', '2019-08-05 10:47:41', NULL);
INSERT INTO `system_log` VALUES (31, 'info', '999999', 'controller not exists:36f8156bcbcbe0a61933.hot-update.json', '2019-08-05 11:05:40', '2019-08-05 11:05:40', NULL);
INSERT INTO `system_log` VALUES (32, 'info', '999999', 'SQLSTATE[42S22]: Column not found: 1054 Unknown column \'menu_id\' in \'field list\'', '2019-08-07 14:03:23', '2019-08-07 14:03:23', NULL);
INSERT INTO `system_log` VALUES (33, 'info', '999999', 'controller not exists:81296877e7b0f245eca6.hot-update.json', '2019-08-07 15:25:10', '2019-08-07 15:25:10', NULL);
INSERT INTO `system_log` VALUES (34, 'info', '999999', 'controller not exists:5db45f92dff44f6c704c.hot-update.json', '2019-08-07 15:27:12', '2019-08-07 15:27:12', NULL);
INSERT INTO `system_log` VALUES (35, 'info', '999999', 'controller not exists:7fef6f0807c6fae7dbcc.hot-update.json', '2019-08-07 17:06:49', '2019-08-07 17:06:49', NULL);
INSERT INTO `system_log` VALUES (36, 'info', '999999', 'controller not exists:7fef6f0807c6fae7dbcc.hot-update.json', '2019-08-07 17:06:49', '2019-08-07 17:06:49', NULL);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `account` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '账号',
  `password` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '密码',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  `avatar` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '头像',
  `introduction` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '介绍',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态',
  `is_super` tinyint(1) DEFAULT NULL COMMENT '是不是超级管理员',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '17605048999', '123456', '2019-07-23 14:41:24', '2019-07-29 14:41:28', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 'Hello World', 1, 1);
INSERT INTO `user` VALUES (4, '17605048993', '123456', '2019-07-29 14:43:06', '2019-07-29 14:43:08', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '3213', 0, NULL);
INSERT INTO `user` VALUES (5, '17605048994', '12345632', '2019-07-23 14:41:24', '2019-07-29 14:41:28', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 'Hello World', 0, NULL);
INSERT INTO `user` VALUES (6, '17605048995', '123456', '2019-07-29 14:43:06', '2019-07-29 14:43:08', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '321321321321333', 0, NULL);
INSERT INTO `user` VALUES (7, '17605048996', '123456', '2019-07-23 14:41:24', '2019-07-29 14:41:28', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 'Hello World', 0, NULL);
INSERT INTO `user` VALUES (8, '17605048997', '123456', '2019-07-29 14:43:06', '2019-07-29 14:43:08', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '213', 0, NULL);
INSERT INTO `user` VALUES (9, '17605048998', '12345621321', '2019-07-23 14:41:24', '2019-07-29 14:41:28', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', 'Hello World321', 0, NULL);
INSERT INTO `user` VALUES (12, '17605048988', '123456', '2019-07-29 14:43:06', '2019-07-30 10:02:25', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '', 0, NULL);
INSERT INTO `user` VALUES (18, '17605048980', '123456', '2019-07-30 17:53:38', '2019-07-30 17:53:38', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '1', 0, NULL);
INSERT INTO `user` VALUES (20, '17605048982', '123456', '2019-07-30 17:54:45', '2019-07-31 11:30:56', '2019-07-31 11:30:56', 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '111', 0, NULL);
INSERT INTO `user` VALUES (21, '17605048888', '123456', '2019-07-30 17:55:13', '2019-07-30 17:55:13', NULL, 'https://wpimg.wallstcn.com/f778738c-e4f8-4870-b634-56703b4acafe.gif', '11111', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_group
-- ----------------------------
DROP TABLE IF EXISTS `user_group`;
CREATE TABLE `user_group` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '组名',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`group_id`,`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user_group
-- ----------------------------
BEGIN;
INSERT INTO `user_group` VALUES (1, 1, NULL, NULL, NULL);
INSERT INTO `user_group` VALUES (2, 21, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_token
-- ----------------------------
DROP TABLE IF EXISTS `user_token`;
CREATE TABLE `user_token` (
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `token` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'token',
  `expire_at` datetime NOT NULL COMMENT '过期时间',
  `create_at` datetime DEFAULT NULL COMMENT '创建时间',
  `update_at` datetime DEFAULT NULL COMMENT '更新时间',
  `delete_at` datetime DEFAULT NULL COMMENT '删除时间',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- ----------------------------
-- Records of user_token
-- ----------------------------
BEGIN;
INSERT INTO `user_token` VALUES (1, 'c0df746dc0cc094830b838f065aa323e', '2019-08-07 17:27:15', '2019-08-07 16:18:19', '2019-08-07 17:07:15', NULL);
INSERT INTO `user_token` VALUES (21, '2ec973ffbefcc8318d3056f6a6bdef47', '2019-08-07 17:26:05', '2019-08-07 17:02:06', '2019-08-07 17:06:05', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
